Brian W
Brian W
Reactions
-
Re: Return "Late" if date is passed and box is unchecked
You're almost there. Try it like this: =IF(AND([Planned Date]2 < TODAY(), Completed2 = 0), "Late", "") Tip: You can also use @row in place of the row number and Smartsheet will…1 ·
